package com.frontResponse.entity;

/**
 * @author WangJie
 * @version 1.0
 * @Description: video相关的sql
 * @date: 2020/7/23 21:56
 * @since JDK 1.8
 */
public interface VideoSql {

    // 查询视频一级分类所有信息
    String SELECT_VIDEO_TOP_SORT = "SELECT tsvid,tsvname,tsvicon FROM front_video_top_sort";

    // 根据视频一级分类id查询二级分类信息
    String SELECT_VIDEO_SECOND_SORT_BY_TSVID = "SELECT ssvid,ssvname,ssvicon FROM front_video_second_sort WHERE tsvid = ?";

    // 根据视频二级分类信息查询视频信息
    String SELECT_VIDEO_INFO_BY_PAGE = "SELECT vid,eptotal,epcnt,attr,title,isclose,img1,img2,img3,img4 FROM front_video_info WHERE ssvid = ? LIMIT ?,?";

    // 根据视频id查询对应的电影信息
    String SELECT_VIDEOSOLO_BY_VID = "SELECT fdncode,title,length,vid,descinfo FROM front_video_solo WHERE vid = ?";

    // 根据视频id查询剧集详细信息
    String SELECT_VIDEO_INFO_BY_VID = "SELECT title,epcnt,vid,descinfo FROM front_video_info WHERE vid = ?";
    String SELECT_TVPLAY_BY_VID = "SELECT fdncode,num,vid FROM front_tvplay_detail WHERE vid = ?";
}
